-- DROPPING ALL TABLES, VIEWS, FUNCTION, STORED PROCEDURE created for BABEL-5112

-- drop view
DROP VIEW test_babel_5112_view;
go

-- drop function
DROP FUNCTION IF EXISTS GetEmployeeSkills;
go

-- drop stored procedure
DROP PROCEDURE IF EXISTS GetEmployeeBasicInfo;
go
-- drop table
DROP TABLE babel_5112_test1; 
GO

DROP TABLE babel_5112_test2; 
GO
DROP TABLE babel_5112_test3; 
GO
DROP TABLE babel_5112_test4; 
GO
DROP TABLE babel_5112_test5; 
GO
DROP TABLE babel_5112_test6; 
GO
DROP TABLE babel_5112_test7; 
GO
DROP TABLE babel_5112_test8; 
GO
DROP TABLE babel_5112_test9; 
GO
DROP TABLE babel_5112_test10;
GO
DROP TABLE babel_5112_test11;
GO
DROP TABLE babel_5112_test12;
GO
DROP TABLE babel_5112_test13;
GO
DROP TABLE babel_5112_test14;
GO
DROP TABLE babel_5112_test15;
GO
DROP TABLE babel_5112_test16;
GO